
<%@page import="java.net.URLEncoder"%>
<%@page import="com.spmanage.util.HttpUtil"%>
<%@page import="com.spmanage.util.DateUtil"%>
<%@page import="com.spmanage.util.BillingUtil"%><%@page import="com.spmanage.util.DbOperation"%>
<%@page import="com.spmanage.util.SqlUtil"%><%@page import="com.spmanage.util.WebAction"%>
<%@page import="com.spmanage.util.StringUtil"%><%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%><%
    System.out.println("盘古接口-报告同步");
	WebAction webAction = new WebAction(request,response);
    String linkId = webAction.getParameterString("linkid");
    String status = webAction.getParameterString("status");
    String userPhone = webAction.getParameterString("mobile");
    String fee = webAction.getParameterString("fee");//不同步
    String spNo = webAction.getParameterString("spnumber");
    String mo = webAction.getParameterString("msg");

    String date = DateUtil.nowTimeTransformCharacter(DateUtil.getNow_Timestamp().toString());
    if(userPhone==null||linkId==null){
    	response.getWriter().write("-1");
    }else{
        response.getWriter().write("0");

 	 	if(linkId.indexOf(',')>0){
		   linkId = linkId.substring(0,linkId.indexOf(','));
		}
        String org = SqlUtil.getStringResult("select org from "+BillingUtil.getSendDay()+" where linkid = '"+linkId+"'",DbOperation.DB_STAT);
        if(org!=null&&org.length()>0) {
        	System.out.println("该linkid已经有同步状态");
        	return;
        }
        
        //String spNo = SqlUtil.getStringResult("select dest from "+BillingUtil.getRecvDay()+" where linkid = '"+linkId+"'",DbOperation.DB_STAT);
       // String mo = SqlUtil.getStringResult("select body from "+BillingUtil.getRecvDay()+" where linkid = '"+linkId+"'",DbOperation.DB_STAT);

    	//指令处理,返回处理后的指令
    	String strMo = BillingUtil.getMo(spNo, mo);
        //获取用户渠道号
        int channelId = BillingUtil.getUserChannel(spNo,strMo);
        int spid = BillingUtil.getUserSpId(spNo,strMo);
        //获取是否要扣量
    	int ischeck = BillingUtil.getCheckSend(linkId);
        int provinceId = BillingUtil.getProvinceId(userPhone);
        
        fee = String.valueOf(BillingUtil.getSpFee(spNo, strMo));
        
        StringBuilder sb = new StringBuilder();
        sb.append("'");
        sb.append(spid);
        sb.append("',");
        sb.append("1");//msgmode
        sb.append(",");
        sb.append("15");//fmt
        sb.append(",");
        sb.append("0");//futype
        sb.append(",");
        sb.append("2");//ftype
        sb.append(",");
        sb.append(fee);//feecode  
        sb.append(",");
        sb.append("'");
        sb.append("");//stype
        sb.append("',");
        sb.append("1");//num
        sb.append(",");
        sb.append("'");
        sb.append(userPhone);
        sb.append("',");
        sb.append("'");
        sb.append(spNo);
        sb.append("',");
        sb.append("'");
        sb.append(userPhone);
        sb.append("',");
        sb.append("getDate()");  //tm
        sb.append(",");
        sb.append("'");
        sb.append("mid");  //mid
        sb.append("',");
        sb.append("'");
        sb.append("msgid");  //msgid
        sb.append("',");
        sb.append("0");//result  DELIVRD
        sb.append(",");
        sb.append("'");
        sb.append(status);//DELIVRD
        sb.append("',");
        sb.append("'");
        sb.append(channelId);//channelId
        sb.append("',");
        sb.append("'");
        sb.append(linkId);//linkid
        sb.append("','"+mo+"'");
        sb.append(",");
        sb.append(provinceId);
        sb.append(",");
        sb.append(ischeck);
            
        SqlUtil.executeUpdate("insert into "+BillingUtil.getSendDay()+"(areaid,msgMode,fmt,futype,ftype,feecode,stype,num,org,dest,fee,tm,mid,msgid,result,stat,infoid,linkid,body,province,ischeck) values("+sb.toString()+")",DbOperation.DB_STAT);
    	
        System.out.println("盘古接口-状态是否需要扣量："+ischeck+",linkid:"+linkId);
        if(ischeck!=1) {	//1为扣量
        	System.out.println("盘古-状态同步:"+SqlUtil.getStringResult("select cpname from adminuser where id = "+ channelId, 5));
        	String http = BillingUtil.getMtUrlByChannel(channelId);
        	if(http!=null&&http.length()>0) {
        		StringBuilder moUrl = new StringBuilder(http);
        		if(moUrl.indexOf("?")>0){
        			moUrl.append("&userPhone=");
        		}else{
        			moUrl.append("?userPhone=");
        		}
    	    	moUrl.append(userPhone);
    	    	moUrl.append("&spNo=");
    	    	moUrl.append(spNo);
    	    	moUrl.append("&linkId=");
    	    	moUrl.append(linkId);
    	    	moUrl.append("&mo=");
    	    	moUrl.append(URLEncoder.encode(mo,"UTF-8"));
    	    	moUrl.append("&date=");
    	    	moUrl.append(URLEncoder.encode(date,"UTF-8"));
    	    	moUrl.append("&fee=");
    	    	moUrl.append(fee);
    	    	moUrl.append("&status=");
    	    	moUrl.append(status);
    		    System.out.println("盘古报告同步地址："+moUrl.toString());
    		    HttpUtil.getHtmlSource(moUrl.toString(),"UTF-8");
        	}
        }
       
    }
    
%>
